﻿CREATE TABLE [dbo].[CultivosPropiedades] (
    [PropiedadGuid]           UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL,
    [CultivoGuid]             UNIQUEIDENTIFIER NOT NULL,
    [CultivoId]               INT              NOT NULL,
    [CicloGuid]               UNIQUEIDENTIFIER NULL,
    [CicloId]                 INT              NULL,
    [JuntaGuid]               UNIQUEIDENTIFIER NOT NULL,
    [JuntaId]                 INT              NOT NULL,
    [EstacionGuid]            UNIQUEIDENTIFIER NULL,
    [EstacionId]              INT              NULL,
    [ClasificacionGuid]       UNIQUEIDENTIFIER NULL,
    [ClasificacionId]         INT              NULL,
    [KilogramosPorHectarea]   DECIMAL (18, 2)  NOT NULL,
    [ProduccionPorHectarea]   DECIMAL (18, 2)  NOT NULL,
    [Fianza]                  DECIMAL (18, 2)  NOT NULL,
    [FolioSV01]               NVARCHAR (50)    NULL,
    [ComentarioSV01]          NTEXT            NULL,
    [DestruccionDeSoca]       NTEXT            NULL,
    [UsaDotacionesEspeciales] BIT              NOT NULL,
    [TieneVariasVariedades]   BIT              NOT NULL,
    [UsaControlDeAgua]        BIT              NOT NULL,
    [UsaControlDeSemilla]     BIT              NOT NULL,
    [UsaGarantiaLiquida]      BIT              NOT NULL,
    [UsaAfianzadora]          BIT              NOT NULL,
    [Status]                  BIT              NOT NULL
);


GO
ALTER TABLE [dbo].[CultivosPropiedades] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = OFF);

